EMT Practice Test

1. Question Content...

---

Question1: If you see the following Filter, then you're working with _______________________ Larger image

Question2: Which of the following are interactive elements that can be added to a dashboard for users?

Question3: How can you change the default Tableau repository location?

Question4: Are animations enabled by default in Tableau?

Question5: How can you format an axis as Bold in Tableau?

Question6: Which one of the following is a dimension?

Question7: Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark.
(Sheet 2)
Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)

Question8: Which of the following are valid ways of Grouping Data?

Question9: _____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.

Question10: When using Animations in a Tableau, which of the following is the default duration for animations?

Question11: To use a quick table calculation, which of the following programming languages do you need to know?

Question12: Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?

Question13: __________ is a technique in Tableau which will identify marks with similar characteristics

Question14: For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

Question15: Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

Question16: According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?

Question17: Is it possible to make a Measure discrete?

Question18: To connect Tableau to a CSV data source what type of connection should you use?

Question19: For Bullet Graphs we need at least ____________ measures

Question20: Which of the following are valid ways to add Totals to a view?

Question21: Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?

Question22: Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

Question23: Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

Question24: Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

Question25: Which Sub-Category had the least Profit in the Office Supplies category?

Question26: _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

Question27: For creating variable sized bins we use __________________

Question28: When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

Question29: Which of the following chart type makes use of 'binned' data?

Question30: How do you identify a continuous field in Tableau?

Question31: Which of the following can you add a reference line to?

Question32: True or False: A reference line cannot be added from the Analytics Pane

Question33: DOWNLOAD THE DATASET FROM:
https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ-574wld4InEplyKT8RP?usp=sharing (if you haven't already) Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?

Question34: _________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

Question35: Which of the following are valid ways to show Mark Labels in the visualisation?

Question36: Dragging a ______________ to colour creates distinct colours for each item whereas dragging a
______________ to colour creates a gradient

Question37: True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

Question38: What is a story point in Tableau?

Question39: Question 45: Skipped
You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?

Question40: Which of the following would you use to connect to multiple tables in a single data source at once?

Question41: DOWNLOAD THE DATASET FROM -
https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! ) How many different countries are present in the dataset?

Question42: ________________ is hosted by Tableau to share our visualisations publically with the world.

Question43: What is the one most important thing you should do after creating a Dual-axis chart?

Question44: Which data type in Tableau does this icon represent?
Larger image

Question45: True or False: Context Filters are executed after Data Source filters

Question46: The calculation [Ship Date] - [Order Date] will return _______________

Question47: True or False: Tableau can create worksheet-specific filters

Question48: You want to add Custom shapes to your visualisation. Where can you add these new shapes?

Question49: The default path for all supporting files, data sources, icons, logs etc is in ______________________

Question50: Which of the following calculations DO NOT need a quick table calculation?

Question51: How can you change the Default Aggregation for a measure in Tableau?

Question52: A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.